<?php include 'connect.php';
 include 'delete.php';
?>
<html>
    <head>
        
    </head>
    <body>
        <?php
        
            $sql= 'select* from student;';
            $student= query($sql);
            //var_dump($student);
        ?>
        <table border="1">
            <h3>STUDENT</h3>
             <tr>
                <td>ID</td>
                <td>Name</td>
               
            </tr>
            <?php
                    foreach ($student as $students):
            ?>
           
            <tr>
                <td>
                    <?php echo ($students['id']); ?>
                </td>
                 <td>
                    <?php echo ($students['name']); ?>
                      <input type="submit" value="delete" get="id">
                </td
                 
                
            </tr>
            <?php            endforeach;?>
            
        </table>
        <?php
            $sql= 'select* from staffs;';
            $staffs= query($sql);
            //var_dump($staffs);
        ?>
        <table border="1">
            <h3>STAFFS</h3>
             <tr>
                <td>ID</td>
                <td>Name</td>
               
            </tr>
            <?php
                    foreach ($staffs as $students):
            ?>
           
            <tr>
                <td>
                    <?php echo ($students['id']); ?>
                </td>
                 <td>
                    <?php echo ($students['name']); ?>
                     <input type="submit" value="delete" get="id">
                </td>
                
            </tr>
            <?php            endforeach;?>
            
        </table>
    </body>
</html>